


local file_path_in "/tochange/"

** county level: merge house price changes at county level to builder data
use "`file_path_in'/builder county/rawBUILDERall_FIPS.dta" , clear 
merge m:1 FIPS_CODE date using "`file_path_in'/house price index/allHPchgs_fips.dta", 
keep if _merge==3 	
drop _merge

saveold "`file_path_in'/builder county/rawBUILDERmergedHP_fips.dta", version(13) replace

** zipcode level: merge house price changes at zip level to builder data
use "`file_path_in'/builder county/rawBUILDERall_ZIP.dta" , clear 
merge m:1 zip date using "`file_path_in'/house price index/allHPchgs_zip.dta", 
keep if _merge==3 	
drop _merge

saveold "`file_path_in'/builder county/rawBUILDERmergedHP_zip.dta", version(13) replace
